<?php
	/**
	*
	*
	*/
	class Complement_Infos {
	
		var $id ;
		var $label;
		var $id_lang;
		
	
		/**
		* Retourne la liste des Domaines.	
		*
		*
		*/
		function getAllComplement(){
			$db = new Db();
			$db->connect();
			
				
				
				$req = $db->query("SELECT * FROM aa_complement_infos order by id");
               
			    $res = $db->fetchArray();
			
			return($res);	
			$db->disconnect();
		}
		
		 public function SELECT_S($constraint="")
		{
			$db = new Db();
			$db->connect();
			
		$sql=" SELECT  ac.id ,ac.label ,a.observation,a.choix FROM `aa_complement_infos` ac 
		LEFT JOIN aa_complement_infos_porteur a ON ac.id = a.label ".$constraint."";
		$req = $db->query($sql);

		//if($constraint){$sql.=" WHERE 1=1 ".$constraint;}if($pagination){$sql.=$pagination;}
		//echo $sql;
		$res = $db->fetchArray();
			
			return($res);	
		}
 
 	
	}

?>